Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Please help.
I want to set the values in the table for the category, but one of the categories should show the data in a different way.
https://drive.google.com/open?id=1nAzp2nEidn85rzOzDEEwKGGDJcrZiObX
Solved! Go to Solution.
Sorry I was away.
Do you mean correct Total?
In that case, you add a new MEASURE referencing previous measure
Please see your amended fiel attached
Measure 2 = IF ( HASONEFILTER ( 'Table'[Category] ), [Measure], SUMX ( VALUES ( 'Table'[Category] ), [Measure] ) )
You can use this MEASURE
Measure = VAR maxmonth = MAX ( 'Table'[Month] ) RETURN IF ( SELECTEDVALUE ( 'Table'[Category] ) = "AU", CALCULATE ( SUM ( 'Table'[value] ), 'Table'[Month] = maxmonth ), SUM ( 'Table'[value] ) )
Sorry I was away.
Do you mean correct Total?
In that case, you add a new MEASURE referencing previous measure
Please see your amended fiel attached
Measure 2 = IF ( HASONEFILTER ( 'Table'[Category] ), [Measure], SUMX ( VALUES ( 'Table'[Category] ), [Measure] ) )
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |