Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to show a factor based on a date; however, I want the aggregate to be the division of the aggregated totals (i.e. . When there is no claim the completion factor is coming in blank, but I would still like it to populate for a row context. I tried using IF(ISBLANK(LOOKUPVALUE... but then that shows rows that have no data. Is there a way to only show data for the rows that have premium data or claims?
Solved! Go to Solution.
@Anonymous wrote:
Is there a way to only show data for the rows that have premium data or claims?
Couldn't you just add these checks to your IF expression ?
eg.
IF ( ISBLANK( DIVIDE( ... )) && ( NOT(ISBLANK( [Gross Premium] )) || NOT( ISBLANK( [Paid Claims] ))) , ...
@Anonymous wrote:
Is there a way to only show data for the rows that have premium data or claims?
Couldn't you just add these checks to your IF expression ?
eg.
IF ( ISBLANK( DIVIDE( ... )) && ( NOT(ISBLANK( [Gross Premium] )) || NOT( ISBLANK( [Paid Claims] ))) , ...
Thank you! Adding in the criteria NOT(ISBLANK(...) around my premium field did the trick!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |