The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I would like to get the following output from in my PowerBI Visualization. The below representation is a matrix in my PowerBI Report. The Value column is a measure. The Measure column is the output I'd like to get.
Essentially, what I'm looking to do is for every customer number, assign the value of Sale Type B to all rows for that Customer Number. Any help would be very much appreciated!
Solved! Go to Solution.
Please try this:-
Measure =
CALCULATE(
[Value],
FILTER(
ALL('Table (3)'),
'Table'[Customer Number] = SELECTEDVALUE('Table'[Customer Number])
&& 'Table'[Sales Type] = "B"
)
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @pbixnewbie ,
You could use the following code:-
Measure =
CALCULATE(
MAX('Table'[Value]),
FILTER(
ALL('Table'),
'Table'[Customer Number] = SELECTEDVALUE('Table'[Customer Number])
&& 'Table'[Sales Type] = "B"
)
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thanks Samarth! I tried this, but the 'Value' field in my table is a Measure itself. Hence, the MAX function doesn't accept it as a parameter. Any suggestions?
Please try this:-
Measure =
CALCULATE(
[Value],
FILTER(
ALL('Table (3)'),
'Table'[Customer Number] = SELECTEDVALUE('Table'[Customer Number])
&& 'Table'[Sales Type] = "B"
)
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin