cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JeanFred
Frequent Visitor

Contextualization of a filter parameter

Hi all

 

I have been posting but it remain unsolved (SO I am re editing message & title)

 

In a page I am struggling with creating a contextualization in the formulas of the entire page

My overall attempt : contextualize depending on the business name that appear on an item somewhere in the page 

 

Seems simple ? yes but so far I never found the right approach

 

The initial formula (that is working well 

JeanFred_0-1630666298017.png

 

 )

 

Text(
Sum(
Filter(
'PROJECTDB';
BUSINESS1>= 1);
(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*BUSINESS1/100)
/1000;"[$-en-us]#,##")

 

So: I am creating an Item called BUSINESSNAME and for this page the value is BUSINESS1 and I am trying this formula 

 

Text(
Sum(
Filter(
'PROJECTDB';
Value(BUSINESSNAME.Text) >= 1);
(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*Value(BUSINESSNAME.Text)/100)
/1000;"[$-en-us]#,##")

 

or this formula :

Text(
Sum(
Filter(
'PROJECTDB';
BUSINESSNAME.Text >= 1);
(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*ValueBUSINESSNAME.Text/100)
/1000;"[$-en-us]#,##")

 

always the same results : no results (empty Item) Instead of properly proceeding the calculation - I know that the 1st way to proceed should work ! but it does not work (probably due to the other elements of the formula)

 

Any Idea? I am REALLY Struggling with it ! 

JeanFred_1-1630666298103.png

 

 

Many thanks

BR

Jean fred

3 REPLIES 3
shoog
Super User
Super User

Label1 is the entire object. If you want to read the text property of the label, you have to use Label1.Text

zmansuri
Super User
Super User

Text(
Sum(
Filter(
'DBNAME';
Value(Label1.Text)>=0);(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*BUSINESSNAME/100)
/1000;"[$-en-us]#,##")

JeanFred
Frequent Visitor

Thank yu for the kind support

 

unfortunatelly when applying it it does not work (both solution show an empty item instead of the expected result 😞

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,421)