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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
19 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
25 | |
10 | |
10 | |
9 | |
6 |