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 have created a measure that shows me if the Venture is "Risky" or "Partial" against each venture. Now I want to count how many trades are "Risky" and how many are "Partial"
Thanks
Solved! Go to Solution.
Hi @muhammadh811 ,
Create 2 measures as below:
_Risky count = CALCULATE(COUNTROWS('Position Manager - Exported_Gra'),FILTER(ALL('Position Manager - Exported_Gra'),'Position Manager - Exported_Gra'[Status]="Risky"))
_Partial count = CALCULATE(COUNTROWS('Position Manager - Exported_Gra'),FILTER(ALL('Position Manager - Exported_Gra'),'Position Manager - Exported_Gra'[Status]="Partial"))
And you will see:
Here,status is a measure per your description.
For details,you may refer to attachment.
https://drive.google.com/file/d/1ty4lgspcNz9loK5ISi-IRfoKdptfMNcW/view?usp=sharing
Find the file
Hope this is what you are looking for if so please mark this as solution and share your Kudoes
Vijay Perepa
Proud to be a Super User!
Just to clarify, I have [Status] as a measure not a column in data.
First I have created a measure which tells me whether a Venture is "Risky" or "Partial". Now I want to see how many Ventures are "Risky".
@muhammadh811
Did you try the solution that I shared, It uses your measure.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Yes if you ignore the column part remaining to measures will tell what exactly you wanted to see.
Proud to be a Super User!
@muhammadh811
You can create two measures as
Risky Count =
CALCULATE(
COUNTROWS('Table'),
FILTER(
Table,
[Status] = "Risky")
)
---------------------------------------------
Partial Count =
CALCULATE(
COUNTROWS('Table'),
FILTER(
Table,
[Status] = "Partial")
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@muhammadh811 , Assume you have create some calculation , where you have like
Switch(True(),
<Condition>, "Risky",
/// and so on,
)
Same way create a measure that returns 1 for risky and 0 or Blank() when it not risky
Sumx(Values(Table[Venture]),
Switch(True(),
<Condition Risky is true>, 1, blank()
))
You can use IF in place of Switch.
I tried your solution but it's not giving the correct number.
@muhammadh811
The measure I shared is not that, please check it again in my reply. I am getting 11 Risky
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Use The measures with Calculate(.....)in my pbix you will get the answer
Proud to be a Super User!
@VijayP
I can't use [Status] = "Risky" in calculate as "Status" is a measure and BI is throwing an error message.
Can you share the measure you have created to get the Risky,Partial. Based on that i can make soltuion out
Proud to be a Super User!
Hi @muhammadh811 ,
Create 2 measures as below:
_Risky count = CALCULATE(COUNTROWS('Position Manager - Exported_Gra'),FILTER(ALL('Position Manager - Exported_Gra'),'Position Manager - Exported_Gra'[Status]="Risky"))
_Partial count = CALCULATE(COUNTROWS('Position Manager - Exported_Gra'),FILTER(ALL('Position Manager - Exported_Gra'),'Position Manager - Exported_Gra'[Status]="Partial"))
And you will see:
Here,status is a measure per your description.
For details,you may refer to attachment.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |