March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello.
I have a test file in pbix and I'm trying to do the same with it as I see in this model:
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/2021-W37/td-p/3760779
Can anyone do the same and repost the file so that I can analyze and learn how it was done?
Thank you.
Solved! Go to Solution.
Hi @RSSILVA_22 ,
First of all, I found that I can not open your .pbix file. Can you change the way to upload the file? Such as sharepoint and so on.
I create a simple example below. Firstly I create a table.
Then I create two measures.
Measure =
VAR _Slicer =
MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Number] )
RETURN
IF (
MAX ( 'Table'[Number] ) >= _Slicer,
UNICHAR ( 128308 ),
UNICHAR ( 128309 )
)
Measure 2 =
VAR _Slicer =
MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Number] )
RETURN
SUMX ( FILTER ( 'Table', 'Table'[Number] < _Slicer ), 'Table'[Sales] )
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RSSILVA_22 ,
First of all, I found that I can not open your .pbix file. Can you change the way to upload the file? Such as sharepoint and so on.
I create a simple example below. Firstly I create a table.
Then I create two measures.
Measure =
VAR _Slicer =
MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Number] )
RETURN
IF (
MAX ( 'Table'[Number] ) >= _Slicer,
UNICHAR ( 128308 ),
UNICHAR ( 128309 )
)
Measure 2 =
VAR _Slicer =
MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Number] )
RETURN
SUMX ( FILTER ( 'Table', 'Table'[Number] < _Slicer ), 'Table'[Sales] )
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
96 | |
82 | |
69 | |
61 |
User | Count |
---|---|
138 | |
115 | |
115 | |
99 | |
98 |