Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello guys,
I have this DAX Function as a calculated column :
So I want to check if "AK_C_CSB" is <= "GW_AblaufCSB" and count the rows where the condition is fulfilled. And then I want to count every row in "AK_C_CSB" which is not null. So the next step is to determine the ratio between the first count and the second count by dividing them together. And then I want to create a card visual where the average of the ratio is shown in my setted slicer time intervall.
My data structure looks like this:
Table "Frachten:
Table "Global"
And this is the result as a table:
And when I want the average of the ratio per month, I get the same result with the value 4,86 for every month.
The most months should be shown the ratio 1 and for a few months the ratio is 0,xx. So the ratio > 1 is impossible.
Here is the file:
Solved! Go to Solution.
Hello thank you for your answer,
but I got this solution now:
@Clout , I think it should be like this measure
DIVIDE(COUNTROWS(FILTER(allselected(Frachten), Frachten[dataum] <= MAX('Global'[dataum]))), calculate(COUNT(Frachten[AK_C_P]),allselected(Frachten)))
Hello thank you for your answer,
but I got this solution now:
User | Count |
---|---|
69 | |
43 | |
21 | |
20 | |
14 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |