Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I am using in a data model a calculation group with 2 items :
Item 1 blank > -
VAR DefaultValue="-" VAR Nb = SELECTEDMEASURE() RETURN if(ISBLANK(Nb),DefaultValue,Nb)
Item 2 blank > 0
VAR DefaultValue=0 VAR Nb = SELECTEDMEASURE() RETURN if(ISBLANK(Nb),DefaultValue,Nb)
It allows me to display a default value instead of "blank".
Everything is OK in the report associated to this datamodel.
I created a composite model on this datamodel and added a table named" Rendez-vous de service" linked to my table "Ordre_Exécution" from the original datamodel
and I experienced the following problem : when i filter my page on a field of the new table and when my selectedmesure returns a blank, the card encounters a problem:
instead of
If I create the calculation group in the report based on composite model, there is no problem.
Do you understand why I have his problem and have you a solution to fix it ?
Thank you
Benjamin
Solved! Go to Solution.
I finally found a solution in the calulation group :
no the selectedmeasure is created in the "first" data model.
I did few other tests.
1/ if I create a measure in the first datamode without using calculation group > same problem
2/ the problem occurs only when default value is "-" but works with "0" value
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |