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.
Hello Everyone,
Can you please help with my measure i.e.
Hi @ARVINDlsllp,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I can't , its size is too large , I have also filtered top 20 with a column reference but some place above DAX is working fine
No, Its nots working
Hello
let me tell you the total of is not correct, i have exported data into excell the total is different in power bi matrix visual. how c=i can fix this?
HI @ARVINDlsllp,
It sounds like a common measure total level calculation issue that appears when your formula needs to calculate with multiple level aggregations, you can try to use following measure formula if it helps:
formula =
SUMX (
SUMMARIZE (
ALLSELECTED ( Append1 ),
[REGIME],
"DC_REF",
IF (
ISFILTERED ( Append1[REGIME] ),
CALCULATE (
DISTINCTCOUNT ( Append1[REF] ),
FILTER ( Append1, Append1[Flag] = "B" )
)
+ CALCULATE (
DISTINCTCOUNT ( Append1[REF] ),
FILTER ( Append1, Append1[Flag] = "C" )
),
CALCULATE (
DISTINCTCOUNT ( Append1[REF] ),
SEARCH ( "C*", Append1[REGIME], 1, 0 ),
FILTER ( Append1, Append1[Flag] = "B" )
)
+ CALCULATE ( DISTINCTCOUNT ( Append1[REF] ), Append1[Flag] = "C" )
)
),
[DC_REF]
)
In addition, you can also take a look at Greg’s blog to know more about this issue:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
User | Count |
---|---|
11 | |
4 | |
3 | |
2 | |
2 |