Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am creating a report where I am showing total numbers,percentage and average score. But It is showing values only for those questions that has non zero value.
I created below measure to calculate total numbers
CALCULATE(DISTINCTCOUNT(Table1[QKey],USERRELATIONSHIP(Table2[QID],Table1[QID]))
I want to show data as below:
Section | Question | Answer | Total Number |
Section1 | 1.1 Ask questions | yes | 32 |
no | 0 | ||
1.2 Leverage resource | Full | 25 | |
No | 7 | ||
Partial | 0 |
But It is showing like this
Section | Question | Answer | Total Number |
Section1 | 1.1 Ask questions | yes | 32 |
1.2 Leverage resource | Full | 25 | |
No | 7 | ||
Can anyone help with solution. Or help in below ques
I have 2 tables. And they are having many to many relationship using QQkey. I want to create one conditional column in Tables 1
If Table1.qekey = Table2.qekey then Table1.qformid else 0
Right click on the Question field and select 'Show items with no data'
If that does not work then use an if statement to return 0.
Measure = IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Table1[QKey],USERRELATIONSHIP(Table2[QID],Table1[QID])))),0,1)
Regards
Ismail
Thanks Ismail. But it didn't solve my problem. When I tried this it started showing all the Questions and Anwers available in table. As shown below in question column 1.1 Accept and 1.1 Insert got added and in Answer column these got added
billing,Neutral,Name,Other 1,Other 2,Payment option
Section | Question | Answer | Total Number |
Section1 | 1.1 Ask questions | yes | 32 |
no | 0 | ||
Neutral | 0 | ||
Name | 0 | ||
1.1 Accept | Yes | 0 | |
No | 0 | ||
1.1 Insert | Yes | 0 | |
No | 0 | ||
1.2 Leverage resource | Full | 25 | |
No | 7 | ||
Partial | 0 | ||
Other 1 | 0 | ||
Other 2 | 0 | ||
payment option | 0 | ||
billing | 0 |