Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Need your help cause I can't find any solution so far.
I have a matrix visual as below with 3 columns (Product, Packsize and Price). I'm trying to write Measures for Price per ml and Price per ml of smallest Packsize.
How to write dax measure for Price per ml of smallest packsize?
Solved! Go to Solution.
@Anonymous
Your first measure:
Price Per ML =
DIVIDE(
SUM(Table2[Price]),
SUM(Table2[Packsize (ml)])
)
Second measure:
Smallest Packsize =
CALCULATE(
FIRSTNONBLANKVALUE( Table2[Packsize (ml)] , [Price Per ML] ),
ALLEXCEPT( Table2 , Table2[Product] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy , I know frist measure but how about the second? I just see a picture.
@Anonymous
Sorry, I forgot to attach it, please check my reply now.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Your first measure:
Price Per ML =
DIVIDE(
SUM(Table2[Price]),
SUM(Table2[Packsize (ml)])
)
Second measure:
Smallest Packsize =
CALCULATE(
FIRSTNONBLANKVALUE( Table2[Packsize (ml)] , [Price Per ML] ),
ALLEXCEPT( Table2 , Table2[Product] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |