The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I need help figuring out how to write this formula in dax.
COUNT IF [F RETAIL FH FIRST/FURTHER] = "FIRST" OR "FURTHER"
Solved! Go to Solution.
Hi @Anonymous ,
Text is not computable for aggregation, I think you need to convert the data type first.
Through here to change the data type:
and then you can do some calculation.
Refer to my pbix file for better understanding.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Anonymous ,
You can try the measure below:
your_measure =
IF (
'F RETAIL FH FIRST'[FURTHER] IN { "FIRST", "FURTHER" },
COUNT ( 'F RETAIL FH FIRST'[FURTHER] )
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Thanks for the answer, but that syntax does not work.
What's the error?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
I dont think and if will work for dax. I am just looking to COUNT [F RETAIL FH FIRST/FURTHER] when its = to "FIRST" OR "FURTHER"
Ok, here is another option:
your_measure =
CALCULATE (
COUNT ( 'F RETAIL FH FIRST'[FURTHER] ),
'F RETAIL FH FIRST'[FURTHER] IN { "FIRST", "FURTHER" }
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Thats not getting me the answer I need. below is the calc I am trying to convert from qlik to pbi. The RTL_First_further is text if that helps.
sum(if(RTL_FIRST_FURTHER = 'FIRST',1,
if(RTL_FIRST_FURTHER = 'FURTHER' ,1,null())))
Hi @Anonymous ,
What is the logic you are trying to convey?
My idea: This is your filtering criteria F RETAIL FH FIRST[FURTHER] = "FIRST" or "FURTHER".
When this condition is met, you need to count or sum some data? Is this what you have in mind?
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
Yes that is exactly what I have in mind. I just need the sum of F RETAIL FH FIRST[FURTHER] after the condition is met, but I have diffucutlties because it is text.
Thanks.
Hi @Anonymous ,
Text is not computable for aggregation, I think you need to convert the data type first.
Through here to change the data type:
and then you can do some calculation.
Refer to my pbix file for better understanding.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 June 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
56 | |
31 | |
30 | |
24 | |
21 |