Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everybody,
I'm stuck with a problem that I'm not able to solve.
I got this expression:
Measure VAL2 is this:
Hi @mlsx4 , it works, but inthis way i cannot compare data.
i have two tables, banks and performances... banks tables is a dimension table in which i have duplicated values banks according to their multiple branches.
in performance table, the fact one, i have two column, numerator and denominator, that i have summed up in VAL 2 measure.
What i'm trying to do is to count all the banks (not branches) that have val 2 > 50 (or 0.5 if in decimal visual).
so i need to take into account that value.
How can i reach that ?
Hi @Damiax
I was not trying to make it work with the definite result, but just to check if the problem is with the condition. I suppose you need to do something else, but I cannot figure out how to do it without the structure or data. Can you post some example (with dummy data)?
Hi @Damiax
True/False Expression are errors mainly related to CALCULATE function. I think the problem is with the part of: Perf>0.5. But without any knowledge about data or structure is difficult to know.
What I would do is to split the expressions. I mean try to do
Measure= CALCULATE(DISTINCTCOUNT(Sportelli[COD_BANCA]),Performance[COD_AREA]=2)
If it works, then the problem is with Perf.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |