Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Hoping for a little assistance on this one.
I have a column with aprox 100.000 rows and 3 different values inside it.
I need a measure (or another way) of dividing these values against eachother to give me the percentage difference between them.
I have not been able to get it to work.
Will appriciate all suggestions
Thanks
Solved! Go to Solution.
@Anonymous ,
To be general, suppose the table is like below.
You may try these steps, firstly, click Modeling-> New Table and create a summarized table using DAX below(You should add a rank column as index).
Table = ADDCOLUMNS(VALUES(Table1[Data]), "Rank", RANKX(VALUES(Table1[Data]), Table1[Data], , ASC, Dense))
Then create another table which contains selection value and create a slicer based on that column, finally create a measure in 'Table' using DAX below and drag the measure to a card visual.
You may also refer to the appendix.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
To be general, suppose the table is like below.
You may try these steps, firstly, click Modeling-> New Table and create a summarized table using DAX below(You should add a rank column as index).
Table = ADDCOLUMNS(VALUES(Table1[Data]), "Rank", RANKX(VALUES(Table1[Data]), Table1[Data], , ASC, Dense))
Then create another table which contains selection value and create a slicer based on that column, finally create a measure in 'Table' using DAX below and drag the measure to a card visual.
You may also refer to the appendix.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |