The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
18 | |
18 | |
17 | |
15 | |
13 |
User | Count |
---|---|
36 | |
35 | |
19 | |
18 | |
18 |