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.
Hello,
I would like to do the caluation (Cat) / (Cat + Dog) from a column. But I have two other metrics I don't want to include in the calauation (Mouse & Rabbit), and would would like to filter out.
The [NoPet] measure is a count of all the pets.
Here is my code but it is not working.
Solved! Go to Solution.
Hi,
I am not sure what visualization you want to present the result, but please try something like,
Pets C/D =
DIVIDE (
CALCULATE ( [NoPet], 'Animals'[Pets] IN { "Cat" } ),
CALCULATE ( [NoPet], 'Animals'[Pets] IN { "Cat", "Dog" } )
)
Or,
Pets C/D =
DIVIDE (
CALCULATE ( [NoPet], 'Animals'[Pets] IN { "Cat" } ),
CALCULATE (
[NoPet],
FILTER ( 'Animals', 'Animals'[Pets] <> "Mouse" && 'Animals'[Pets] <> "Rabbit" )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi there!
Can you provice de DAX code of [NoPet].
In the meantime you can try:
Pets C/D =
DIVIDE(
CALCULATE( [NoPet], 'Animals'[Pets] = "Cat" ),
CALCULATE( [NoPet], 'Animals'[Pets] IN { "Cat", "Dog" } )
)
Let me know if that helps!
Hi,
I am not sure what visualization you want to present the result, but please try something like,
Pets C/D =
DIVIDE (
CALCULATE ( [NoPet], 'Animals'[Pets] IN { "Cat" } ),
CALCULATE ( [NoPet], 'Animals'[Pets] IN { "Cat", "Dog" } )
)
Or,
Pets C/D =
DIVIDE (
CALCULATE ( [NoPet], 'Animals'[Pets] IN { "Cat" } ),
CALCULATE (
[NoPet],
FILTER ( 'Animals', 'Animals'[Pets] <> "Mouse" && 'Animals'[Pets] <> "Rabbit" )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you! The top one works perfectly. I'm using it in a line chart to compare the percentage of cats to dogs over time.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |