Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I want to count from measure "Multi", "Solo"
I used this measure
Solved! Go to Solution.
HI @MSAYED26,
You can try to use the following measure to calculate the result based on current measure value group:
formula =
VAR summary =
SUMMARIZE (
ALLSELECTED ( Table1 ),
[Materials],
"M1", [Measure1],
"M2", [Measure2]
)
RETURN
COUNTX (
FILTER ( summary, [M2] IN VALUES ( NewTable[Materials] ) ),
[Materials]
)
Regards,
Xiaoxin Sheng
I used the measure but no data
HI @MSAYED26,
You can try to use the following measure to calculate the result based on current measure value group:
formula =
VAR summary =
SUMMARIZE (
ALLSELECTED ( Table1 ),
[Materials],
"M1", [Measure1],
"M2", [Measure2]
)
RETURN
COUNTX (
FILTER ( summary, [M2] IN VALUES ( NewTable[Materials] ) ),
[Materials]
)
Regards,
Xiaoxin Sheng