Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to get the Product_id_count with a few filters. But which ever method I try, I am not able to get it.
My requirement is to get the distinct count of product_id's
where
(calculated_Product_rating_table[Overall_Approval__Rate>60%]=TRUE
or
calculated_Product_rating_table[TV_Approval__Rate>50%]=TRUE
or
calculated_service_rating_table[TV Repeat >= 150%])=TRUE
or
calculated_service_rating_table[Overall Repeat >= 300%])=TRUE)
I tried the below formulas but none of them worked, all gave me one or the other error. Hence asking you for help.
Regards
-Shashanth
Solved! Go to Solution.
Guys, I was able to find a solution. A collegue of mine helped me.
Basically we created an other table WITHOUT USING SUMMARIZE(I did not know this was possible/allowed)
Guys, I was able to find a solution. A collegue of mine helped me.
Basically we created an other table WITHOUT USING SUMMARIZE(I did not know this was possible/allowed)
@Shashanth , Try like
product_id_count = CALCULATE(DISTINCTCOUNTNOBLANK(calculated_Product_rating_table[product_id]),filter(values(calculated_Product_rating_table[product_id]), OR(or(calculated_Product_rating_table[Overall_Approval__Rate>60%]=TRUE,calculated_Product_rating_table[TV_Approval__Rate>50%]=TRUE),or(LOOKUPVALUE(calculated_service_rating_table[Overall Repeat >= 300%],calculated_Product_rating_table[product_id],calculated_service_rating_table[product_id])=TRUE,LOOKUPVALUE(calculated_service_rating_table[TV Repeat >= 150%],calculated_Product_rating_table[product_id],calculated_service_rating_table[product_id])=TRUE))))
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit,
Thanx for your response.
I am not able to get this working.
Still not sure what the error is.
And wrt sharing a sample file, I am not able to do it since it is a direct query mode to the servers with lot of data.
Is there any ther solution that you can help me out with?
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |